package dao;

import java.sql.*;
import java.util.ArrayList;

import util.DBHelper;

public class ActivityOptionDAO {
	
	
	public ArrayList<String> getAO() throws SQLException{
		Connection conn = DBHelper.getConnection();
		Statement stmt;
		ResultSet rs;
		ArrayList<String> al = new ArrayList<String>();
		stmt = conn.createStatement();
		rs = stmt.executeQuery("select * from activityoption");
		
		while (rs.next()) {
			al.add(rs.getString(2));
		}
		rs.close();
		stmt.close();
		conn.close();
		
		return al;
	}
}
